FACTORBASE : SQL for Multi-Relational Model Learning
نویسندگان
چکیده
We describe FACTORBASE , a new framework that leverages a relational database management system (RDBMS) to support multi-relational graphical model learning. The basic insight behind our approach is that an RDBMS can be leveraged to manage not only big data, but also to manage big models [1, 2]: First, model structure and model parameters can be managed efficiently without having to be stored in main memory. Second, the Structured Query Language (SQL) supports constructing, storing, and transforming structured statistical objects. The FACTORBASE system uses SQL as a high-level scripting language for statistical-relational learning of a graphical model structure. Our implementation shows how the SQL constructs in FACTORBASE facilitate fast, modular, and reliable program development. Empirical evidence from six benchmark databases indicates that leveraging database system capabilities achieves scalable model structure learning.
منابع مشابه
FactorBase: SQL for Learning A Multi-Relational Graphical Model
We describe FACTORBASE , a new SQL-based framework that leverages a relational database management system to support multi-relational model discovery. A multi-relational statistical model provides an integrated analysis of the heterogeneous and interdependent data resources in the database. We adopt the BayesStore design philosophy: statistical models are stored and managed as first-class citiz...
متن کاملSQL for SRL: Structure Learning Inside a Database System
The position we advocate in this paper is that relational algebra can provide a unified language for both representing and computing with statistical-relational objects, much as linear algebra does for traditional single-table machine learning. Relational algebra is implemented in the Structured Query Language (SQL), which is the basis of relational database management systems. To support our p...
متن کاملnD-SQL: A Multi-Dimensional Language for Interoperability and OLAP
We propose a multi-dimensional language called nD-SQL with the following features: (i) nD-SQL supports queries that interoperate amongst multiple relational sources with heterogeneous schemas, including RDBMS and relational data marts, overcoming the mismatch between data and schema; (ii) it supports complex forms of restructuring that permit the visualization of ndimensional data using the thr...
متن کاملThe CTU Prague Relational Learning Repository
The aim of the CTU Prague Relational Learning Repository is to support machine learning research with multi-relational data. The repository currently contains 50 SQL databases hosted on a public MySQL server located at relational.fit.cvut.cz. A searchable meta-database provides metadata (e.g., the number of tables in the database, the number of rows and columns in the tables, the number of fore...
متن کاملA Relational Database Approach to Polyphonic Music Search Systems Using Regular Expressions
We present a model for a database of multi-track polyphonic songs searchable via regular expressions and stored in a relational database. The database is a standard off-the-shelf SQL-based relational database management system. The regular expression format used is of our own design, but could be replaced by any equivalent format. Songs are culled from non-analog sources such as MIDI and decomp...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2015